﻿--获取单个人的职级异动记录
CREATE proc [dbo].[proc_Employee_GradeMove_GetPersonList]
	@eid int
as
	select
		Id, 
		Eid,
		(select EName from Employee  where EId=Id) as EName,
		(select Title from Grade G where id= AGradeId) as GradeName,
		(select Title from Grade G where id= BGradeId) as BGradeName,
		Item,
		Reason,
		Proposer,
		ApplionTime,
		FirstAudit,
		FirstMemo,
		FirstAuditPerson,
		FirstAuditTime,
		SecondAudit,
		SecondMemo,
		SecondAuditPerson,
		SecondAuditTime
	from
		Employee_Grade
	where 
		eid=@eid
		and secondAudit=1
